SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406571 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406571 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411661,234887,550594,1018337,450833,135757,817926,27710,87611,599056,774358,719419,1022271,680208,322307,446591,331018,441268,1012629,7581,104725,249405,586729,539834,519275,12877,611442,239471,769508,104284,170220,895254,152995,795942,630724,433765,1003931,106326,997211,1012889,250583,582560,690691,926432,83399,195551,753169,487401,942334,509311,810090,530112,40234,725543,762767,164448,756223,783578,1045952,378093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002647s ]