SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011028 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011028 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139657,343253,116013,846804,802625,135248,141354,904758,139250,49641,804540,565991,154286,264237,164982,93215,422845,793194,579887,416860,916220,363772,437716,208010,613383,257993,423192,396363,988697,828502,787240,675018,278556,400679,118805,463814,702008,899498,403621,607125,213000,139828,699913,639321,818668,417686,937718,862297,158325,838301,928536,122775,17112,918841,592285,26211,755493,708852,1038819,655070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]