SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405071 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405071 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336553,567450,949705,4665,380007,973185,325152,987240,480765,225551,689690,971388,115564,960349,19570,29497,132274,205574,923378,806036,849173,832984,356081,635331,490623,22475,995403,836169,496867,400877,756473,559843,1016555,458977,370812,534989,755628,537588,830074,579794,924211,307421,350791,240223,871895,642075,116906,687712,356089,486468,1047703,148808,636809,852610,581989,551457,1025726,927443,789795,828439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]