SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439081 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439081 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952533,462861,734262,324453,835008,32757,744098,378247,27195,936942,675041,111879,171086,406763,119934,605971,590676,436991,72295,894057,960800,963412,13717,149290,621553,699600,534500,557586,224204,465178,640183,574359,346925,602458,294741,927572,195954,962511,956915,184062,43558,779719,854174,631130,1013486,474021,191967,868486,358057,893054,648427,968953,371560,148409,380668,387795,64557,702798,246871,439289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]