SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49110 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49110 [ RunTime:0.003497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771188,83278,983944,657207,264187,640248,648847,938825,39141,779263,316920,513458,572486,52433,868548,775543,764004,781642,427846,346218,982215,841632,34094,24629,243920,942931,95658,360653,677060,685958,210723,437912,38120,38353,76017,68511,619232,128777,290607,26967,136042,348623,336481,890813,922013,80280,127715,837112,694111,113413,379321,4384,549771,850312,640733,101859,69707,844999,481728,271137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]