SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454203 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454203 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912630,459348,424224,622841,400598,1038215,279644,270901,909253,777924,839421,171259,725440,256281,437940,102913,723992,575882,238576,143435,933973,534598,172471,273226,284204,236508,621686,212386,411393,766179,561298,199809,482236,682249,922530,977951,933239,611131,72235,626418,332321,886443,495180,615569,702598,387357,903842,405407,407201,578745,956265,281163,937651,417065,1046009,525463,427237,673142,619924,617572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004284s ]