SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584433 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584433 [ RunTime:0.004800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902252,560991,412933,420837,347604,984007,45419,120386,556154,358385,1040979,345954,893872,846040,931143,731470,101295,382008,864186,669451,450079,558511,386537,336063,1038944,111023,476558,819219,343568,884187,492681,551247,725262,622077,763758,1025108,402131,892091,576456,244318,887631,212873,674532,1013150,699032,506084,168934,302684,756175,208768,360420,157470,903535,856227,92183,1021093,332764,30124,563876,668689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]