SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042875 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042875 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984064,17090,391400,673264,838309,961821,430766,3688,853288,843439,685214,822665,1006114,446468,924020,129792,198089,49055,261578,683621,373753,272942,500217,863069,67544,160335,190145,663956,635946,576094,444049,920112,74111,116915,1031908,229161,660758,441298,141297,505921,279933,759254,212280,435156,535775,428634,913716,649099,597087,652282,483050,465510,1040888,434754,9390,238619,600806,166036,686897,803227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]