SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420762 LIMIT 1 [ RunTime:0.008053s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420762 [ RunTime:0.003302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238224,1025670,829450,828864,454426,302238,924326,1008170,403543,44966,446801,400457,1047217,593105,390916,585780,226628,195555,650480,284060,228392,3139,545790,233754,994662,732851,584118,143110,608542,40452,859853,1026371,868493,199306,974141,274439,580322,463853,645768,869176,278772,95468,407256,107462,1048373,302549,353644,603523,824501,821116,1032692,30811,259349,940271,677245,241915,225526,708314,83173,1024875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004072s ]