SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419718 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419718 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162529,179187,275793,854450,656138,1018010,630672,650027,604767,125706,393601,1013100,632660,215731,679797,954051,710623,626041,820624,1029181,629321,591191,682214,340607,63681,430872,853551,89620,562906,56730,654935,46584,536026,729019,412043,993836,1041983,909412,1003693,724441,224826,883232,615345,663221,250592,937380,467622,10083,627972,650162,1013250,945424,809380,520154,517329,619248,751437,186598,666790,424225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]