SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311879 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311879 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488077,970596,882118,618130,129632,776570,359069,1029945,579752,858045,852511,609591,1015040,533648,573380,39094,468194,396436,69695,569581,789557,1041393,785062,537047,371138,788301,87309,821797,830988,554739,635847,726755,207852,162585,385117,177405,756974,457718,37238,537397,120248,945463,973253,705153,877883,796260,160296,296921,360929,193661,861173,569977,29153,352328,277111,1027423,924038,888064,809220,861799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001018s ]