SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037531 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037531 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026292,754923,490090,546488,316335,1019453,503476,692859,766185,745532,532407,150169,404943,853028,170576,781164,1014449,227450,469746,934455,516783,323244,157677,761685,649990,63227,999954,698390,524109,411470,161900,575232,154432,99176,118140,310634,464013,877915,386868,465948,778683,473976,270579,541680,905802,160786,380823,622287,166339,200019,217879,836477,259213,870496,272071,779298,340526,197486,1035213,501122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]