SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567712 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567712 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77374,732278,556367,1020644,274447,970175,408222,575125,880303,694081,845807,630393,80725,323724,621561,512351,879161,89467,172501,318727,196334,810658,524396,320125,372144,515862,304204,557830,114707,979597,961813,310834,81949,370583,1686,148914,397995,578923,340751,786687,593324,1014923,825448,629341,69254,361841,1033890,967540,172686,110093,740746,744350,512572,878785,454031,16170,576253,790656,25385,990876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]