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` = 429437 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429437 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124350,560430,392747,1031212,667090,859146,622753,122959,917158,791558,284177,174672,980178,476262,133195,967761,975058,215186,470048,229848,144872,656606,715120,166594,604122,372275,916929,1007810,278128,86589,81805,665382,93771,237136,860243,379228,444635,618865,894607,785867,38221,590364,863329,550364,308981,36340,203291,423485,536202,1010624,938589,660258,660240,558190,1041428,800878,31270,675843,419341,502451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]