SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320210 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320210 [ RunTime:0.004477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185581,280712,1031915,962299,262120,961656,79732,333038,805886,533070,989092,937609,524756,657126,118859,838779,795107,954765,103053,994264,902271,133300,189074,806168,991133,308989,193938,113572,27610,581456,281247,961795,95083,886323,470371,405237,398077,745587,648175,203520,1025620,494815,359126,261739,738815,62475,431498,552535,55274,608196,967287,411766,669217,713163,619168,492315,808208,81819,892963,375312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]