SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10330 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10330 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211790,1038850,35554,452517,448236,562191,289558,880813,179496,115694,826767,153591,371049,641406,911843,687537,2724,158273,307009,655367,664159,730221,677540,120488,357240,542676,800429,611978,914822,336517,652491,890525,124622,797501,801139,320500,38947,87639,128065,496245,790061,1024293,722011,105358,251465,537146,456302,910285,7666,8005,777835,134269,241001,183117,144464,108761,792811,441866,788651,986617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]