SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 852009 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 852009 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663758,855700,611713,80300,286036,399933,482861,559112,366134,591677,265546,599643,965423,625670,1032074,646968,905127,385989,921235,782210,178866,422376,133116,928166,89302,904744,655977,8455,48364,876062,84595,3304,882590,843435,412563,960983,979305,593977,325650,541081,142893,146111,931619,777563,45878,520747,177753,626344,291853,283952,149634,277555,710880,557446,881744,268290,717527,103578,214324,1046585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 852009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 852009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001443s ]