SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543183 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543183 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940839,953194,201228,391736,618305,83780,739123,44083,794883,950111,487967,789064,454862,630143,611803,844656,41843,557589,686208,589362,566759,123230,856923,622539,995803,897396,860008,257111,105254,918779,298132,785936,659138,485589,1020148,1011875,298081,201977,295590,65926,456384,578032,4062,958412,284411,148611,564134,914204,1032121,45583,98763,669349,149636,622255,495714,230664,50818,265884,646077,569489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]