SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418984 LIMIT 1 [ RunTime:0.001974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418984 [ RunTime:0.003761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52479,884820,1022120,719906,478696,772924,744980,527345,24879,896880,783334,989210,801052,14874,387393,1004213,845345,929064,815356,484989,112877,128447,530431,596546,20024,38720,833940,757176,943531,72054,411656,963577,83299,610897,912273,948390,379790,548584,730433,752999,740102,843074,390645,397030,330771,4106,266495,23309,903376,611751,110586,393228,705535,301478,7799,746795,202985,633480,510325,168631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003923s ]