SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408619 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408619 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233965,201505,789323,218726,710727,879859,75670,930991,550141,95463,168813,84244,801959,16466,236459,433409,390343,631050,739359,796142,679921,927296,191154,493797,519705,104831,427407,922386,806727,911199,660887,782077,347461,554100,282566,149777,806335,300022,393987,420604,347184,598496,490419,730105,694903,837082,200967,597201,462982,945162,6061,406787,312854,691033,92993,948781,896123,932141,314774,998415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]