SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368743 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368743 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627407,332396,586369,934052,283671,802026,330059,1019372,231053,719327,690940,952477,1019599,672060,962898,782460,997471,506352,177310,741928,834639,159672,46489,812849,56090,737175,511724,683067,984243,815696,552123,529523,437690,747914,278986,631149,453555,382063,541798,611015,373568,781485,99441,434729,191773,838800,920416,197206,283797,941127,797827,890428,836749,188737,570823,1003105,582388,1015151,780964,99146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]