SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039477 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039477 [ RunTime:0.004851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540484,179560,429452,547553,118553,777083,816815,235088,508796,608809,708176,245587,500286,452859,535688,313172,462272,5065,364342,485064,511550,744650,1038346,611567,579305,761449,991566,490484,830764,756296,564021,749339,434558,466439,680429,283029,493982,435315,800988,643703,336110,576030,226686,115650,389083,11109,178884,689396,416879,85211,385467,467473,75462,717761,834557,312025,744629,373061,1039666,993662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]