SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040929 LIMIT 1 [ RunTime:0.001783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040929 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34791,545308,684136,993604,330377,912750,148737,698024,904732,682638,888125,542528,681262,341078,776950,667299,795811,762609,89050,324655,91271,257750,300121,167209,624171,760956,586841,362936,662405,541592,729014,495774,470292,374377,973056,272654,28614,310128,777055,690799,568917,354665,726957,997814,477959,1021167,623102,591292,499339,240599,689258,415262,445228,200005,677002,71079,804146,180165,519450,48853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]