SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200018 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200018 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287637,148384,1036644,371378,453945,817016,729139,1032272,449756,769199,47068,752862,706280,1046197,767644,304770,240429,141379,391349,990085,52080,339428,874300,740309,528966,660894,208874,693803,333697,239155,987459,490220,281072,875858,570415,680268,690707,154841,122678,528428,589776,331741,643884,384804,834296,916724,1043981,616421,1035003,728589,868008,622030,1035619,619424,575957,638251,347484,221883,746658,986184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]