SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151085 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151085 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672850,355961,650452,852991,888859,871482,724001,201919,702475,41995,460415,1048476,359663,838756,496581,786955,528114,97304,474818,321042,187226,819438,266777,425570,478655,961719,190894,501707,171158,85077,401538,986705,1030656,131978,365833,212986,260182,513639,896984,250161,838130,505598,167566,888428,645643,598276,763062,380189,347092,1041394,385854,1024417,170287,247994,874990,334021,570319,393068,192631,401047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001475s ]