SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338976 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338976 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930050,510401,20610,611570,711351,403640,1016905,841779,737530,804501,423932,251492,20361,172104,476020,264756,518981,243977,715015,1003519,628963,835219,1040112,888134,839056,506710,598227,104473,501936,798120,502405,604998,538027,320179,494277,807446,779187,597046,974458,907643,748424,357954,435877,458067,1011841,654523,395004,377749,10650,253119,455368,583737,165129,221381,1019945,464508,684657,882394,690561,772403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]