SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120518 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120518 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314639,408847,43080,71445,1047924,199468,852252,562524,959965,1036866,331965,831959,248587,633161,264440,385108,401071,30227,937589,11738,307819,710420,150355,561148,98672,39218,362553,534505,11380,950437,496620,106753,50311,1013445,702653,670112,585449,108780,255649,178929,497059,283009,943243,154892,619293,512294,542149,296546,631283,342708,1002795,230750,95797,94942,642802,101319,391829,770835,999098,585221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001982s ]