SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047650 LIMIT 1 [ RunTime:0.001220s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047650 [ RunTime:0.005833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649414,921305,127679,873483,761918,742539,696438,190282,481807,301551,668337,378658,881821,229850,274191,7220,399062,393921,1043993,289941,193878,677554,1024494,956651,39764,980400,480484,230910,202257,538309,442012,312960,1020107,238887,765014,858644,873631,424196,173158,906511,701276,9919,783466,106433,907244,319905,396734,745719,531074,839631,682820,710393,342187,404046,522310,16482,677653,797065,729109,320592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]