SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974290 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974290 [ RunTime:0.005262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769282,240627,696608,521015,713890,896086,741883,867405,903602,281219,690869,591168,767818,138692,689513,580354,771418,1043648,67428,620392,334533,515219,835260,317985,100265,77067,142339,299438,623487,1005270,808992,389793,825811,1020581,482164,26137,900987,752738,173440,198931,857730,522085,257755,795938,351532,492116,22250,381528,207591,531047,981888,29848,820633,563080,1021620,433674,991424,490790,174054,370165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]