SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506063 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506063 [ RunTime:0.003771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389868,890239,643733,393858,770635,407379,621213,99658,203846,199400,205411,450458,709395,982976,871492,580062,644892,888052,163172,1024163,485289,31806,970710,290068,901047,219455,920367,888639,92561,386620,593991,112196,556077,168631,407479,950853,280316,1035921,575467,429532,677230,658756,813358,87998,526750,981037,112952,592840,951967,716480,350164,828067,236683,310531,208257,416740,669139,168250,1048751,52834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]