SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308980 LIMIT 1 [ RunTime:0.001546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308980 [ RunTime:0.003355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503964,974994,838453,618919,651946,717392,402850,589945,44817,567280,377118,688889,471697,997749,311326,510305,813537,45014,600514,606690,390778,358936,329028,377934,908706,829551,624112,222115,514294,958654,272519,104404,20824,305734,661592,890968,539525,286143,880921,717977,509324,342952,81060,430745,163784,934351,766834,618386,13232,802090,282298,472341,940847,428752,350363,887390,959131,897772,1329,209438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000908s ]