SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039220 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039220 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986926,944825,498679,758390,671239,818448,629658,378559,968482,904089,731236,147010,211227,90329,607295,4060,727963,182880,467614,830256,739959,323165,45696,1004438,592374,872881,612433,358856,822088,635568,1026725,445929,447555,1021256,634241,558477,11119,508857,958534,847684,361649,625036,489455,347,760209,248130,990083,484326,105009,766379,713112,595012,722139,967705,384986,159770,515093,614414,631636,1029979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002238s ]