SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027384 LIMIT 1 [ RunTime:0.001064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027384 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844205,796174,380898,991972,833973,295441,735964,991870,501222,1016794,560519,442471,940572,392350,611309,168095,893301,995792,267185,203425,130481,917426,423656,889194,737797,911889,353314,536541,995817,346037,666130,35801,887799,807013,640844,734486,672249,1023011,752929,358335,587915,305339,697175,394511,80960,700745,223189,260965,648213,132223,259850,606544,599614,549783,447611,254806,249652,63541,210969,52585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]