SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173401 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173401 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016642,104245,983966,418921,773530,285932,1033527,961986,729836,938544,709743,497472,387574,347220,460581,750482,376506,108397,995676,890206,189638,531987,810880,909019,213008,475228,74287,961139,544169,989230,945660,495801,511786,100367,63110,43688,607392,698134,342967,899094,365791,621194,870787,239146,483546,666669,751143,665303,864373,231167,185318,349553,840607,256175,762367,719455,424036,43596,1026469,537928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]