SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020967 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020967 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247045,597059,190969,13385,647513,416108,245862,483031,492548,642465,995029,413018,440254,636124,1045453,376016,438211,325380,1014801,59909,415878,63106,973191,388675,1510,504332,564006,436534,152796,750604,695211,752834,378125,992758,996376,595951,276633,297004,972399,354317,688696,334216,975401,482621,841709,125320,274062,911473,706069,384895,763640,436653,159437,126097,651202,732590,611075,796317,620729,416973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]