SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501191 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501191 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316636,674970,311461,675660,411102,327493,514452,279981,20928,304570,641871,613160,896074,834495,764839,669939,910205,1039436,857618,784965,543149,482837,4866,435476,573591,763985,104818,665809,769317,483744,221432,82938,346138,89291,613460,304427,905122,600909,167154,800406,957847,660333,389541,576526,576364,432673,873725,440082,765209,259581,836659,455057,490130,853389,923071,366781,1032660,276990,93152,567610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001826s ]