SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402595 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402595 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958974,669112,681726,551670,460289,1006541,961442,401396,990075,63014,102469,719134,796177,617552,509157,257920,422136,662409,538737,693317,784456,785621,545757,746133,910208,684426,35307,477930,52792,514617,642837,342902,779677,921503,1036097,1010831,47694,564317,228969,566448,1040351,772487,10830,371777,158908,638572,859772,692327,635853,722874,109734,629452,454821,183554,3873,175308,374606,461767,186279,808496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]