SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447839 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447839 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788988,668945,1016963,194634,497529,479292,933055,911346,401093,1009674,985127,720931,71777,623718,300483,407754,206293,995489,769291,588411,122356,57934,103719,465492,81861,33272,702155,468428,507059,805247,524057,422449,928489,541963,21271,599786,549887,414632,757837,938413,454261,182312,888130,270326,331323,84248,75548,81319,298278,589031,896944,889353,85704,638677,910086,888519,597440,38339,738616,700258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]