SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354390 LIMIT 1 [ RunTime:0.001715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354390 [ RunTime:0.003632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836399,930948,715718,810551,703075,899680,58310,632563,399313,76290,961130,942649,630002,371578,677679,724660,27785,19471,420308,546414,542663,307164,745270,605669,280595,69932,124653,136460,562868,669374,781823,974720,188538,691114,35154,514135,85857,691291,353823,107856,446900,539542,738443,15670,550521,2804,1004588,142340,1956,3522,319378,903395,879238,444997,293676,388322,595337,472591,484844,989022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]