SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412057 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412057 [ RunTime:0.002665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457709,833113,109696,797205,903091,332563,70253,351734,557300,76032,140803,665557,207885,682970,66816,704381,79546,683556,933605,896298,51496,511486,648375,492292,235809,857411,711687,128437,965610,360823,870324,953259,715991,4922,142912,224642,556367,435642,1016853,913584,290461,460213,361503,164232,127764,656844,43188,487640,855570,746960,177518,348460,58025,153089,218209,700182,690141,533984,433046,465339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]