SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542002 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542002 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973402,298258,429817,724163,502008,620144,589408,755046,582260,990012,349997,986109,75666,40225,247581,104961,186459,749847,300697,689572,936763,881944,663148,334857,259919,222828,64597,11417,606998,448567,663262,416764,413200,923069,670716,413601,309213,514683,783926,409924,946803,702453,554222,746934,829710,182818,683229,964319,219954,461989,101261,845406,630937,870995,142203,673537,986853,272128,313327,1027834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]