SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542820 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542820 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39529,954453,625030,770021,185506,1024121,184981,1000408,721376,254871,215521,120833,1047824,999759,769804,219598,983897,349830,421849,267706,281778,807090,966621,736573,631167,694320,227154,397933,780032,1037857,382559,344445,888549,421220,160425,964998,513601,759984,758402,920539,665743,427096,314521,253259,1009120,806194,786586,956875,1031645,1048315,746707,750472,667797,686420,307555,577147,694337,362453,690933,760696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001182s ]