SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510679 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510679 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825118,284568,1014403,577319,991215,228648,282483,131498,392456,447057,296455,304173,252994,29329,553727,676217,910417,171255,120112,782922,301991,13326,817929,607734,411547,579246,251003,254955,1043914,601042,69401,991239,1014015,581130,1009418,305211,914989,911190,726222,826067,66996,882301,659089,239547,316933,349502,506837,643993,329882,871053,570728,618677,1032164,370964,17490,111127,338416,209665,686851,124769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]