SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 166008 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 166008 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409078,781414,188996,317661,14056,623332,8228,956171,811264,706705,446643,417288,825813,153670,378395,256082,435510,252651,776463,62637,385795,393603,307460,296779,705233,3359,785169,289869,948582,499904,149721,896368,180643,131794,975437,160507,682391,683157,714408,187235,848285,517211,531228,265471,589315,432447,703165,578090,264800,596925,1048016,746768,98447,898410,566611,706093,335824,47532,467148,98425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 166008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 166008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]