SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511418 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511418 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812951,868476,861644,88249,73015,483973,471847,140925,327517,357890,634808,856732,825451,154127,248693,498495,925784,484020,808253,292471,154064,5547,153791,497792,22631,325067,343286,200979,545294,152576,134099,297733,440643,547869,292771,804931,361226,497282,465572,124773,613124,306885,827970,811332,715716,414372,214889,254970,443743,871455,167,579823,111408,317689,724175,1037003,340206,306137,893048,353840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]