SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015942 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015942 [ RunTime:0.004278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352,634743,805191,323380,1008581,710579,266394,392296,926548,865133,801892,910869,278426,846973,970987,438219,42423,317417,903029,749241,933463,790404,35836,443257,353842,863524,994455,901904,598712,943161,407247,28460,197049,99147,303338,512616,1015178,924565,166583,90407,288208,1036472,353606,45900,209094,848166,732260,823669,51205,83168,645561,351774,175114,21102,360296,634058,968765,816164,250663,423160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]