SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449523 LIMIT 1 [ RunTime:0.001185s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449523 [ RunTime:0.003261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532216,467184,801566,34765,824891,803627,620860,587505,667261,510529,998178,536848,279020,94028,130984,744028,228991,706912,832360,201641,114019,72398,581083,829894,328009,440039,39383,630701,741589,613018,742989,596604,658743,669623,894150,205042,820948,3835,734658,1040967,220142,77918,457675,586000,2915,517021,301310,630451,99019,211501,513642,774136,738105,238027,637265,65929,937448,350274,248857,45078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001967s ]