SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029420 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029420 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15360,397466,362267,317369,1046632,301100,943612,868598,510780,746815,1029369,914331,240463,446118,279901,917584,689070,800801,577373,480801,846424,60208,170618,880623,1003693,160491,411812,601546,960039,323029,613103,554984,757365,490315,229080,680179,892077,261485,547374,8648,380694,993464,780755,134821,544722,218457,720041,795974,787356,261292,966917,468690,940339,924568,1011698,779689,363860,953149,792809,71601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]