SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298401 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298401 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508958,15183,332054,594837,361569,36061,246873,599390,105538,569946,344229,771776,872713,36225,542279,128659,682006,525605,276902,940203,256175,163249,567014,381412,890153,217997,1015015,273727,614776,46960,262182,168514,490139,821095,713960,391049,605101,49123,942125,865939,776706,52451,442169,631797,701974,553793,491620,966723,980795,570370,780991,977244,231754,1010975,1046529,740074,464770,541228,1032480,751909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003218s ]