SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012513 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012513 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311106,510956,127054,362291,538109,265142,534656,787433,477800,6597,405473,854743,899711,5068,443586,539645,640434,508786,105122,394007,127581,479639,367952,10027,801351,599450,1008490,678370,477450,780112,687084,890267,36295,213627,1031924,443274,297398,253233,897360,257290,97917,390389,430589,164605,581951,492954,871758,542379,50383,332624,25730,582809,324474,960190,513629,181490,713327,608256,295910,717121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]