SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548091 LIMIT 1 [ RunTime:0.000609s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548091 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825519,768408,590911,521933,498012,506087,1008219,120508,697504,1014057,402893,185930,4334,12285,346847,347892,709956,690743,958559,877378,837023,698618,100573,1004669,473144,692200,402171,985396,816253,182983,690096,670615,958911,982942,982012,9540,779843,65110,258837,521534,511212,177423,1004711,546246,288528,132829,406423,1017706,457049,443079,623518,511007,10134,287487,922676,801567,741426,898194,1014269,58973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]