SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021101 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021101 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708644,436950,465044,282972,351147,790649,995544,33550,856965,959277,192525,600143,197099,38359,522659,259434,165161,750568,338902,200119,511625,471291,230329,838141,892618,180684,102088,72505,80422,662518,238577,533805,981305,797822,101732,699512,616823,462692,672956,792996,723518,641651,381498,695968,281637,150799,779509,508829,426427,279393,473288,944967,390219,936275,622883,185137,402344,93186,641002,228902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001966s ]