SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499908 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499908 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401987,606412,303122,427518,252039,830477,312213,504208,495110,952499,990118,186936,941467,703518,670549,557711,142842,848106,609932,527961,631793,321519,736048,601906,327695,767383,116181,655511,989672,730385,954148,941688,428192,1037567,314797,687376,440059,196504,1040789,492426,97099,262481,939311,39096,356597,646515,996609,671868,517581,780847,1008503,451648,130643,1036551,668149,897675,840355,183636,506265,282530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]