SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514203 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514203 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486138,122479,1033356,843125,204919,665817,107657,130001,1009059,815810,1046345,233596,498941,707378,25513,155135,216155,926025,535463,789024,937483,977421,815141,307834,379245,641534,90882,736719,624013,642007,955738,176607,369365,25056,535989,282228,850601,82585,534111,274030,953918,295476,202243,7566,405065,347117,705190,601761,192202,386002,29060,580799,527150,293890,416234,566110,204003,178872,309056,425292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]