SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406357 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406357 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486510,191045,748293,870272,663820,753624,514634,177145,392246,301542,1005888,823978,679426,1029448,1015610,881706,368879,378305,98745,287630,1015192,413109,987717,93671,462524,619177,993929,1001104,539144,596168,294916,1028130,266017,825390,1002552,401223,837760,956858,688557,785508,921630,712716,511974,327572,404915,868660,236430,533315,546811,157512,886609,263076,822708,563918,300137,292707,1011476,17435,595948,301198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406357 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406357 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]