SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200498 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200498 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987504,976410,463657,626422,191285,679539,257768,1013050,420505,708312,535160,952161,873751,377952,376594,878743,905109,120485,883345,87817,488293,674104,277662,710858,691861,533850,5906,155855,162062,882939,163078,687692,957906,197775,26784,924292,106003,202631,566955,845790,988939,363582,697740,839172,572629,571529,135895,840309,396002,46805,229824,337754,435249,562783,44398,69603,105208,235646,757566,43686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]