SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320014 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320014 [ RunTime:0.004673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352745,761633,127670,40696,22363,361112,371221,982678,410182,626953,420950,618005,541379,1029908,524632,973334,221684,378410,8330,1028146,736910,1019796,274484,749429,375389,629194,220654,784986,616961,839179,616268,1036484,195096,42274,82857,768677,295545,1019675,640377,1009712,499937,782450,196590,465645,108032,880395,70495,99702,540855,703915,841957,232480,617489,232526,834011,982385,793835,349067,713582,313033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]