SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340145 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340145 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411666,398094,926559,778740,654495,475457,976934,974480,408467,304740,349577,412970,561129,568696,1041207,820177,743631,1047000,156897,928222,10884,199120,130717,500898,96850,158610,1010389,554677,172710,512450,749033,294464,458297,260408,240777,252300,443158,1003952,971179,678353,557171,325102,356248,814886,1002730,1029052,690804,911360,850886,391678,208192,19712,630788,831658,217174,65156,809572,650935,380653,746447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]