SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 639618 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 639618 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534425,529122,1012040,802134,399656,719437,524423,363330,872574,207120,490985,81272,141973,331295,424092,401608,1044211,80757,808613,714786,266208,27440,762232,146427,750476,710702,975695,142693,6272,769624,70530,961015,765702,206618,517542,946807,38875,478168,846183,101287,275943,182137,327448,334093,450518,441789,150396,785243,563018,430503,306373,729357,390775,187612,19843,56340,517802,197346,273656,346839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 639618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 639618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]