SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3341 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3341 [ RunTime:0.003060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265283,872510,246318,675093,302079,200764,274855,830668,514437,381741,814968,413956,743183,940601,934909,540014,492817,808576,219602,797669,125412,253895,187311,717980,279762,920507,209917,284248,798697,272120,981830,985074,936762,56921,356430,436202,708005,542311,430778,679077,688994,730585,987268,789940,1024795,707168,909454,993280,311101,643431,609565,120510,541,211801,815050,263612,503339,477036,889185,384381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]