SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54173 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54173 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271690,582644,180707,898464,919436,106315,499910,744691,1033154,225750,917065,572389,904067,841835,550347,492855,333351,928539,984428,941243,413610,708547,643532,655555,620519,515648,640580,517830,287135,806380,483327,377922,493932,807281,512288,279880,123317,982385,365967,438903,809917,1020617,54156,103986,36828,277144,621115,970779,1000560,272492,425602,844597,859137,583443,127951,247701,25150,672386,530621,220759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]