SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38040 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38040 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308508,615695,1005700,901672,786805,540345,813598,698523,303730,149222,189759,398350,1045324,413839,276373,309626,464398,549221,138385,539947,1038322,28784,280813,21543,577919,1004300,693945,729442,817859,489038,510060,574154,463533,824896,324482,856112,274570,854891,821017,369917,328353,309525,330633,334134,476398,569004,626495,425176,254603,469671,563248,1039243,830250,908991,120174,147739,939927,828722,84022,377019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]