SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405828 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405828 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888220,548087,354678,50363,237301,681869,504516,2161,1031052,62540,576957,636517,519014,725671,478604,530744,289392,883007,80199,392234,74595,752508,147514,793896,402657,398891,111777,438412,15109,1038907,123073,262293,254657,388310,255614,977198,740870,808301,401745,293621,377977,383372,974633,741548,581248,981036,1043808,846367,104068,549821,590291,1033579,162155,297550,781915,421000,79435,257189,643121,301664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]