SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340437 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340437 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132348,451359,684925,609464,336275,498738,97466,779265,596963,728756,823054,289011,578289,986570,978454,804140,899247,959380,1001028,377316,348395,87921,144992,298382,466382,1043424,114043,885794,1008247,729317,157505,151170,1001329,74628,657002,85023,742861,258041,189125,193194,985374,700031,560469,943046,199733,784326,187132,940958,1015173,236882,95829,654590,908251,200572,265671,119370,114891,54432,394562,331672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]