SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417657 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417657 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329371,715075,359558,590084,950016,310341,86714,690685,677797,670031,358881,659523,867641,334408,251376,561039,71755,201108,867856,265836,857125,228203,876546,871594,581608,871877,899824,742662,300708,508228,732952,483409,1012015,1017713,475652,621219,22950,709062,679108,672311,738853,716068,112078,99958,406878,904946,263628,17755,278499,502669,647904,483889,594717,227685,91494,298306,320260,343433,558645,537089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]