SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039686 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039686 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018577,72937,223112,409240,291254,689260,666270,653374,598143,738605,344042,606008,22162,732955,986099,665575,453473,274010,672617,786167,244140,405110,592036,349069,85531,800827,605808,159445,195361,286888,794224,965150,904290,818102,305901,878343,645431,368089,761993,261565,764132,845763,116482,620689,623614,453175,661676,506755,401397,176752,128458,415419,383684,777859,338588,27276,327151,653500,852325,676962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]