SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311300 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311300 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10200,438516,879026,459350,313410,852790,890432,197080,876081,554320,311884,380992,128870,138798,427794,706057,543460,570778,19812,977415,828469,807527,882170,76146,10828,753357,608454,468718,440161,33708,1000173,255730,943643,153240,949126,352467,318561,524245,620957,128357,100828,815357,603380,781961,911524,371731,954679,1000039,1044793,841019,44999,789235,64958,881266,530038,579697,1043272,554591,598837,8930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]