SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103282 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103282 [ RunTime:0.003704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680314,448081,424847,790296,905210,862218,702374,848034,1031478,443755,283363,239390,4613,17695,721069,15039,135126,56515,744283,119075,1012374,909034,970888,478895,933660,325469,204561,281883,706097,604096,945693,437394,176148,668998,597260,567589,72060,655831,978862,104895,728039,848491,873258,667495,400898,135302,56068,791601,498888,592646,909326,693329,136745,211525,228009,697417,389791,759166,270418,312492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]