SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199015 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199015 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189446,215185,810644,133208,45663,257336,194323,824623,578746,182923,228975,71454,884314,793235,293944,645641,137671,333739,613703,365836,611616,606167,705639,125121,949602,44758,528645,12528,642666,445916,180095,831267,76728,254524,743280,766285,756724,715314,484771,870343,109265,739488,743521,513463,354821,394106,442835,986185,470160,751577,564894,780840,401974,770817,319221,602790,491870,269186,859717,101450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]