SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482083 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482083 [ RunTime:0.003294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008262,771018,4142,655410,735659,1018502,179226,987440,537279,635830,545549,19092,624882,194703,400640,437135,422875,617346,871063,860366,556512,547865,380196,489525,22483,792369,723807,391091,115995,76315,912034,182101,822296,725380,351043,806418,592507,188135,993117,81933,489937,796882,304482,333301,138908,757528,892937,985611,39503,897812,482674,162955,575942,458226,636791,811484,310893,243660,507193,478456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]