SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539223 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539223 [ RunTime:0.003079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365218,804119,246431,334383,120049,848633,49335,152262,92558,942909,702038,756296,141654,105717,380648,213995,123055,615925,635491,730981,213680,236132,1041499,562417,14083,1027705,387931,626602,442384,727189,187051,821905,248603,588645,1009703,590940,168290,858989,214553,705091,267252,707860,34696,331854,494885,833514,685058,420675,1023629,493666,728920,911310,472932,1033742,562122,344266,674663,741287,84141,741172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]