SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001536 LIMIT 1 [ RunTime:0.001563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001536 [ RunTime:0.002947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374298,682891,818085,121622,937190,113976,694147,87861,755001,477106,387883,944575,521134,105896,504399,395106,793978,212966,826837,402865,861503,520062,322625,497917,868015,699040,150036,504117,1012310,84719,944216,1011783,47307,147029,230909,330779,129879,241869,466159,557380,671331,676079,412156,25650,500768,411267,425600,553729,303271,381256,247542,597427,884678,620713,125778,309764,242481,108000,492585,961711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]