SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406318 LIMIT 1 [ RunTime:0.001919s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406318 [ RunTime:0.003832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207951,883332,656243,892773,620753,658571,764833,728455,234237,296228,421753,955485,944990,687743,927144,499710,215637,202206,23055,282926,140796,231660,638469,244767,570842,1038124,825894,456949,854692,175172,265811,727338,124727,346338,979040,493340,393612,267307,726499,534079,1037063,226548,861490,234170,1014726,414269,161955,283170,613577,847805,816793,327154,1012321,875095,384289,557015,250010,3615,129720,293386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]