SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324484 LIMIT 1 [ RunTime:0.001044s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324484 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440441,1007404,1026408,189359,304992,497068,276699,746640,979056,834863,184767,152659,1018719,240798,220969,780985,372036,474462,822958,476991,697965,486789,801789,195798,824702,715745,966514,441939,327042,348671,356473,152501,279390,948477,1038603,900793,872820,173774,843966,306984,361285,540449,328672,646055,395995,74432,173014,787135,923204,578393,253002,320192,56909,757278,883443,508381,449012,646244,656394,372257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003660s ]