SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101801 LIMIT 1 [ RunTime:0.001223s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101801 [ RunTime:0.007326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37667,429905,1019377,312151,409418,899881,683960,178632,332790,232437,723063,539132,505546,170865,115900,311219,726073,248057,5030,86320,817184,961645,744434,597663,252254,315423,611941,307077,480087,1022348,629387,48504,459497,850643,698810,489989,987724,697398,82584,993673,930734,973893,720295,760591,484427,920782,416641,625394,304308,468900,557006,744500,230232,841444,618753,951497,377488,489664,648457,143616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002888s ]