SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016023 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016023 [ RunTime:0.003309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408748,964846,746380,32114,342544,771699,783634,972705,762321,897587,536853,510423,662431,404499,810252,170792,236986,725604,398850,693706,105032,873864,883369,303009,717682,495654,167161,843233,974051,1020199,247929,228364,390784,840661,303187,242918,640888,605361,345976,193373,590740,807400,580246,471088,553051,95826,9989,203583,978851,228619,716784,191368,906106,931067,467792,648253,841471,742645,201065,236664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]