SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104882 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104882 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165375,831099,65347,553488,267606,214737,1016334,285945,825864,969236,794189,190743,689406,376732,540381,531576,434664,500078,912676,480222,634494,808158,514638,630194,637173,305553,991062,867532,564166,890891,993130,981408,105380,71174,385696,819353,577731,580430,862026,831610,181666,800962,637487,286772,503734,401690,127057,893924,1026039,765727,644415,129251,279514,574516,598623,104804,252240,525712,730069,529049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]