SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200306 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200306 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418925,603855,394890,169892,629374,557955,313578,841008,766189,600853,727123,802546,704242,576595,24199,14446,992042,465665,722103,973500,623377,429360,921300,355697,986614,485496,776264,314027,328552,86723,586491,98849,8755,297829,950072,353349,824619,339111,173105,296215,247798,293616,576759,583801,116893,828553,967080,740696,186736,756912,603784,992642,842351,909460,241968,372910,412272,158760,482331,177124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002261s ]