SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200909 LIMIT 1 [ RunTime:0.002080s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200909 [ RunTime:0.005774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009633,375817,759609,273763,626853,640131,11645,527361,916987,849270,994658,488076,287993,376516,512589,506108,27479,64012,741883,908810,921330,723249,429233,726403,506816,498013,914884,1041491,828531,940015,336239,867407,586453,692526,1010743,998007,510605,528079,2994,971532,714019,386448,957073,23183,378238,352291,928885,727971,957422,320610,432800,828779,433572,904973,1010388,551357,172216,448557,754589,48608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003426s ]