SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206680 LIMIT 1 [ RunTime:0.000804s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206680 [ RunTime:0.007087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36192,726028,80614,730162,1011432,1044642,420865,988381,239535,594254,137317,805524,13545,456610,1043072,915597,318449,80111,491270,621659,159885,248979,256830,928533,454625,829511,481857,943125,325531,875300,747962,943817,577721,371960,1024010,361924,129907,1015456,707259,919251,265108,179997,487111,1011702,1024278,144864,801267,811558,475432,847527,749468,131867,50755,233854,525019,127600,935660,140469,531010,110556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]