SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58054 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58054 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638669,321429,588902,351566,606117,598745,87370,378658,800356,77132,909475,978701,636739,510308,1007747,546109,373668,261430,62696,867288,208166,683059,23503,944327,790752,283874,86669,180339,265918,58449,663822,20238,818695,622866,167788,908568,132113,653980,653186,456410,298476,125304,955416,517484,793683,718930,968383,473226,450033,131342,953320,769466,626867,621901,737376,733959,370980,345929,529413,293727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004048s ]