SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406134 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406134 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621848,368871,610951,885583,272824,602794,200624,134365,90812,436574,982404,403537,1645,917025,271480,329924,611879,196258,279910,1029623,1042451,514481,371942,509105,1023711,329177,122439,937043,915141,659820,774414,285316,571789,430257,244507,734415,88575,640501,969051,331574,924969,80702,119643,710345,786383,507840,1028008,926205,242619,412728,657105,801935,663218,12599,923640,954476,382246,273242,497867,61138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]