SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413470 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413470 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845123,656401,91953,198906,305670,541283,648937,867050,1040261,288203,928785,827219,127043,667344,551446,497192,1013496,68491,419829,56541,71111,976215,595108,50600,470220,1011760,344831,734119,733450,613154,319442,45891,826671,631466,990044,1014516,266025,192953,743469,820864,51621,921672,517635,927544,707517,400963,194165,253279,780292,555068,924282,854158,877298,942964,559744,123919,315723,108191,355955,1028885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]